MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

42 rows where Object Name = 9252

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Highlight, Is Public Domain, Department, Title, Culture, Period, Artist Prefix, Artist Display Name, Artist Alpha Sort, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Region, Subregion, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
141348 141348 74.51.767 0 1 240354 Greek and Roman Art 12 Pyxis 9252 Terracotta alabastron (jar) Mycenaean 4009 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Terracotta 160 H. 3 in. (7.6 cm.) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases 410   http://www.metmuseum.org/art/collection/search/240354 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
141353 141353 74.51.772 0 1 240359 Greek and Roman Art 12 Pyxis 9252 Terracotta alabastron (jar) Mycenaean 4009 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Terracotta 160 H. 3 13/16 in. (9.7 cm.) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases 410   http://www.metmuseum.org/art/collection/search/240359 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
141976 141976 74.51.1420a, b 0 1 240983 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Cypriot 3578 Cypro-Archaic                         late 7th–6th century B.C. -625 -500 Terracotta 160 H. 1 5/16 in. (3.3 cm); diameter 1 3/4 in. (4.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases 410   http://www.metmuseum.org/art/collection/search/240983 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
145739 145739 74.51.5890 0 0 244762 Greek and Roman Art 12 Pyxis 9252 Pyxis Greek, Corinthian 4000 Late Corinthian                         ca. 575–550 B.C. -599 -500 Terracotta 160 H. 4 5/16 in. (11 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases 410   http://www.metmuseum.org/art/collection/search/244762 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
145740 145740 74.51.5891 0 0 244763 Greek and Roman Art 12 Pyxis 9252 Pyxis Greek, Corinthian 4000 Late Corinthian                         ca. 575–500 B.C. -599 -500 Terracotta 160 H. 4 1/4 in. (10.8 cm) diameter 4 1/2 in. (11.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases 410   http://www.metmuseum.org/art/collection/search/244763 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
145741 145741 74.51.5892 0 0 244764 Greek and Roman Art 12 Pyxis 9252 Pyxis Greek, Corinthian 4000 Late Corinthian                         ca. 575–550 B.C. -599 -500 Terracotta 160 H. 3 1/8 in. (8 cm) diameter 3 3/8 in. (8.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases 410   http://www.metmuseum.org/art/collection/search/244764 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
145802 145802 75.2.20a, b 0 1 244826 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Corinthian 4000 Late Corinthian                         late 6th century B.C. -525 -500 Terracotta 160 H.: 2 7/8 in. (7.3 cm) Gift of Samuel G. Ward, 1875                       Vases 410   http://www.metmuseum.org/art/collection/search/244826 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
148164 148164 06.1021.154a, b 0 0 247318 Greek and Roman Art 12 Pyxis 9252 Pyxis Greek, Attic 4006 Classical                         late 5th century B.C. -430 -400 Terracotta 160 Other (.a overall height): 1 3/8 × 1 7/16 in. (3.5 × 3.6 cm) Diameter (.b lid): 1 1/2 in. (3.8 cm) Height: 3/8 in. (1 cm) Rogers Fund, 1906                       Vases 410   http://www.metmuseum.org/art/collection/search/247318 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
148264 148264 06.1021.253a, b 0 0 247418 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, South Italian, Apulian, Canosan 4145 Early Hellenistic                         late 4th–early 3rd century B.C. -330 -275 Terracotta 160 H. 5 1/2 in. (14 cm) diameter 10 1/2 in. (26.7 cm) Rogers Fund, 1906                       Vases 410   http://www.metmuseum.org/art/collection/search/247418 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
148378 148378 06.1116 0 1 247534 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (cosmetic box) East Greek 3999 Classical                         1st half of 5th century B.C. -499 -450 Terracotta 160 H.: 4 1/2 in. (11.4 cm) Rogers Fund, 1906                       Vases 410   http://www.metmuseum.org/art/collection/search/247534 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
148749 148749 07.286.36a, b 1 1 247916 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Attic 4006 Classical         Attributed to the Penthesilea Painter     Penthesilea Painter 12982       ca. 465–460 B.C. -465 -450 Terracotta 160 H. 4 3/4 in. (12.1 cm) H. with cover 6 3/4 in. (17.2 cm) Rogers Fund, 1907                       Vases 410   http://www.metmuseum.org/art/collection/search/247916 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
148990 148990 09.221.40a, b 0 1 248178 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Attic 4006 Classical         Attributed to the manner of the Meidias Painter     Meidias Painter 12921       ca. 420–410 B.C. -420 -410 Terracotta 160 H.: 3 1/4 in. (8.3 cm) Diam.: 4 in. (10.2 cm) Rogers Fund, 1909                       Vases 410   http://www.metmuseum.org/art/collection/search/248178 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
149383 149383 11.212.3 0 1 248584 Greek and Roman Art 12 Pyxis 9252 Engraved bronze pyxis (small box with lid) Etruscan 4056 Archaic                         ca. 675–625 B.C. -675 -625 Bronze 23 H. 1 13/16 in. (4.6 cm) diameter 2 in. (5.1 cm) Rogers Fund, 1911                       Bronzes 419   http://www.metmuseum.org/art/collection/search/248584 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
151809 151809 21.88.63 0 1 251087 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Corinthian 4000 Late Corinthian                         mid-6th century B.C. -575 -525 Terracotta 160 H. 4 1/4 in. (10.8 cm); diameter of mouth 3 3/16 in. (8.1 cm) Rogers Fund, 1921                       Vases 410   http://www.metmuseum.org/art/collection/search/251087 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
153617 153617 28.57.5a, b 0 0 252957 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis lid (box lid) Greek, South Italian, Apulian, Canosan 4145 Early Hellenistic                         late 4th–early 3rd century B.C. -330 -275 Terracotta 160 H. with lid 5 3/16 in. (13.2 cm) H. of box 3 5/8 in. (9.2 cm) diameter of box 8 5/8 in. (21.9 cm) Fletcher Fund, 1928                       Vases 410   http://www.metmuseum.org/art/collection/search/252957 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
154137 154137 35.11.21a, b 0 1 253498 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Corinthian 4000 Late Corinthian                         2nd half of the 6th century B.C. -550 -500 Terracotta 160 total H. 6 7/8 in. (17.4 cm) Fletcher Fund, 1935                       Vases 410   http://www.metmuseum.org/art/collection/search/253498 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
154212 154212 39.11.8a, b 0 0 253580 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Attic 4006 Classical         Attributed to the Wedding Painter     Wedding Painter 13298       ca. 460–450 B.C. -460 -450 Terracotta 160 H. with cover 4 5/8 in. (11.8 cm); H. without cover 3 3/8 in. (8.5 cm); greatest diameter of body 4 15/16 in. (12.5 cm) Fletcher Fund, 1939                       Vases 410   http://www.metmuseum.org/art/collection/search/253580 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
154835 154835 41.162.44 0 1 254211 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Corinthian 4000 Late Corinthian                         ca. 575–550 B.C. -575 -550 Terracotta 160 H. 4 3/4 in. (12.1 cm); diameter 7 3/16 in. (18.3 cm) Rogers Fund, 1941                       Vases 410   http://www.metmuseum.org/art/collection/search/254211 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
155541 155541 57.12.3 0 1 254941 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Corinthian 4000 Middle Corinthian         Apparently by the Hermitage Painter     Hermitage Painter 13385       ca. 590–570 B.C. -590 -570 Terracotta 160 H. 4 3/4 in. (12.1 cm) Gift of Ernest Brummer, 1957                       Vases 410   http://www.metmuseum.org/art/collection/search/254941 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
155724 155724 62.11.7 0 1 255128 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Corinthian 4000 Late Corinthian                         ca. 525 B.C. -525 -525 Terracotta 160 H. 3 11/16 in. (9.3 cm) diameter 2 5/8 in. (6.7 cm) Purchase, Mrs. Helen H. Mertens Gift, 1962                       Vases 410   http://www.metmuseum.org/art/collection/search/255128 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
155856 155856 68.11.41a, b 0 1 255265 Greek and Roman Art 12 Pyxis 9252 Pyxis Greek, South Italian, Apulian 4057 Late Classical         Attributed to the Kantharos Group     Kantharos Group 13097       ca. 325–300 B.C. -325 -300 Terracotta 160 H. 11.91 cm. Rogers Fund, 1968                       Vases 410   http://www.metmuseum.org/art/collection/search/255265 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
155857 155857 68.11.42a, b 0 1 255266 Greek and Roman Art 12 Pyxis 9252 Pyxis Greek, South Italian, Apulian 4057 Late Classical         Attributed to the Kantharos Group     Kantharos Group 13097       ca. 325–300 B.C. -325 -300 Terracotta 160 H. 11.99 cm. Rogers Fund, 1968                       Vases 410   http://www.metmuseum.org/art/collection/search/255266 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
155858 155858 68.11.43a, b 0 1 255267 Greek and Roman Art 12 Pyxis 9252 Pyxis Greek, South Italian, Apulian 4057 Late Classical         Attributed to the Stoke-on-Trent Group: "Pouting Lips" Sub-Group     Stoke-on-Trent Group: "Pouting Lips" Sub-Group 13414       ca. 300 B.C. -300 -300 Terracotta 160 H. 7.01 cm. Rogers Fund, 1968                       Vases 410   http://www.metmuseum.org/art/collection/search/255267 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
156046 156046 1972.118.147a, b 0 1 255458 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Attic 4006 Classical         Attributed to the Marlay Painter     Marlay Painter 13137       ca. 430 B.C. -440 -420 Terracotta 160 H. 2 3/16 in. (5.6 cm); diameter 7 3/16 in. (18.3 cm) Bequest of Walter C. Baker, 1971                       Vases 410   http://www.metmuseum.org/art/collection/search/255458 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
156047 156047 1972.118.148a, b 0 1 255459 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (box) Greek, Attic 4006 Classical                         ca. 420–400 B.C. -450 -400 Terracotta 160 H. 6 7/8 in. (17.5 cm) Bequest of Walter C. Baker, 1971                       Vases 410   http://www.metmuseum.org/art/collection/search/255459 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
156772 156772 1995.497 0 1 256227 Greek and Roman Art 12 Pyxis 9252 Terracotta box of a pyxis Cycladic 4182 Early Cycladic I                         ca. 3200–2800 B.C. -3200 -2800 Terracotta 160 H.: 2 1/2 in. (6.4 cm) Diam.: 4 7/16 in. (11.2 cm) Purchase, Claude Claire Grenier Gift, 1995                       Vases 410   http://www.metmuseum.org/art/collection/search/256227 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
157528 157528 1999.423 0 1 257428 Greek and Roman Art 12 Pyxis 9252 Terracotta pyxis (cylindrical box) Minoan 4162 Late Minoan III                         ca. 1400–1100 B.C. -1400 -1100 Terracotta 160 diameter 10 1/4in. (26cm) Gift of Alexander and Helene Abraham, in honor of Carlos A. Picón, 1999                       Vases 410   http://www.metmuseum.org/art/collection/search/257428 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
202835 202835 51.131.27a–k 0 1 324173 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragments Iran 5660 Iron Age III                         ca. 8th–7th century B.C. -800 -600 Ivory 148 1.88 x 0.24 in. (4.78 x 0.61 cm) Fletcher Fund, 1951           Iran 347 said to be from Ziwiye 61         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/324173 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
202852 202852 51.131.24 0 1 324190 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragment Iran 5660 Iron Age III                         ca. 8th–7th century B.C. -800 -600 Ivory 148 2.01 x 0.67 in. (5.11 x 1.7 cm) Fletcher Fund, 1951           Iran 347 said to be from Ziwiye 61         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/324190 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
202853 202853 51.131.25 0 1 324191 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragment with a winged, human-headed lion Iran 5660 Iron Age III                         ca. 8th–7th century B.C. -800 -600 Ivory 148 1.73 x 0.67 in. (4.39 x 1.7 cm) Fletcher Fund, 1951           Iran 347 said to be from Ziwiye 61         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/324191 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
202854 202854 51.131.26 0 1 324192 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragment Iran 5660 Iron Age III                         ca. 8th–7th century B.C. -800 -600 Ivory 148 2.87 x 0.55 in. (7.29 x 1.4 cm) Fletcher Fund, 1951           Iran 347 said to be from Ziwiye 61         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/324192 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
203350 203350 57.168 0 1 324728 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragments Iran 5660 Iron Age III                         ca. 8th–7th century B.C. -800 -600 Ivory 148 1.46 x 0.63 in. (3.71 x 1.6 cm) Gift of Elie Borowski, 1957           Iran 347 said to be from Ziwiye 61         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/324728 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
203546 203546 59.107.17 0 1 324937 Ancient Near Eastern Art 14 Pyxis 9252 Cloisonné furniture or cosmetic box plaque with three frontal heads Assyrian 5654 Neo-Assyrian                         ca. 8th–7th century B.C. -800 -600 Ivory 148 1.02 x 2.52 x 0.51 in. (2.59 x 6.4 x 1.3 cm) Rogers Fund, 1959           Mesopotamia 335 Nimrud (ancient Kalhu) 5         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/324937 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
203925 203925 61.147a, b 0 1 325340 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis Iran 5660 Iron Age                         ca. 7th–6th century B.C. -700 -500 Bronze 23 1.73 in. (4.39 cm) Rogers Fund, 1961           Iran 347           Metalwork-Vessels 607   http://www.metmuseum.org/art/collection/search/325340 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
204324 204324 65.163.29 0 1 325758 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragment Iran 5660 Iron Age II                         ca. 9th century B.C. -900 -800 Ivory 148 0.94 x 1.42 in. (2.39 x 3.61 cm) Rogers Fund, 1965           Iran 347 Hasanlu 101         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/325758 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
204375 204375 65.163.80 0 1 325809 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragment Iran 5660 Iron Age II                         ca. 9th century B.C. -900 -800 Ivory 148 2.24 x 2.32 x 0.31 in. (5.69 x 5.89 x 0.79 cm) Rogers Fund, 1965           Iran 347 Hasanlu 101         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/325809 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
204376 204376 65.163.81 0 1 325810 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragment Iran 5660 Iron Age II                         ca. 9th century B.C. -900 -800 Ivory 148 1.65 x 1.06 x 0.2 in. (4.19 x 2.69 x 0.51 cm) Rogers Fund, 1965           Iran 347 Hasanlu 101         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/325810 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
204377 204377 65.163.82 0 1 325811 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragment Iran 5660 Iron Age II                         ca. 9th century B.C. -900 -800 Ivory 148 1.65 x 1.46 x 0.39 in. (4.19 x 3.71 x 0.99 cm) Rogers Fund, 1965           Iran 347 Hasanlu 101         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/325811 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
204722 204722 1976.233.3 0 1 326176 Ancient Near Eastern Art 14 Pyxis 9252 Pyxis fragment Iran 5660 Iron Age II                         ca. 9th century B.C. -900 -800 Ivory 148 1.06 x 0.79 x 0.12 in. (2.69 x 2.01 x 0.3 cm) Purchase, The Adelaide Milton de Groot Fund, in memory of the de Groot and Hawley families, 1974           Iran 347 Hasanlu 101         Ivory/Bone-Vessels 609   http://www.metmuseum.org/art/collection/search/326176 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
318785 318785 1998.298a, b 1 1 453576 Islamic Art 9 Pyxis 9252 Pyxis (Cylindrical Container)                             late 11th–early 12th century 1075 1125 Stonepaste; luster-painted on incised, opaque white glaze 47236 Bowl: H. 8 in. (20.3 cm) Diam. 5 1/2 in. (14 cm) Lid: H. 3 5/8 in. (9.2 cm) Diam. 5 1/2 in. (14 cm) Wt. 8.5 oz. (241 g) Purchase, Lila Acheson Wallace Gift, Harvey and Elizabeth Plotnick Gift, and Louis E. and Theresa S. Seley Purchase Fund for Islamic Art, 1998 Attributed to 20       Syria 69             Ceramics 5   http://www.metmuseum.org/art/collection/search/453576 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
329900 329900 1970.324.5 0 1 471973 The Cloisters 17 Pyxis 9252 Pyxis Spanish 13                           ca. 950–75 950 975 Elephant ivory 25301 Overall: 4 5/8 x 4 1/8 in. (11.7 x 10.5 cm) The Cloisters Collection, 1970 Made in 1 Cordoba 2057   Andalusia 731 Spain 5             Ivories 181   http://www.metmuseum.org/art/collection/search/471973 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
400955 400955 SL.12.2016.46.2 0 0 655795 Islamic Art 9 Pyxis 9252 Wine Vessel with Hebrew Inscription                             late 12th–early 13th century 1175 1225 Brass; inlaid with silver 44858 Height: 8 11/16 in. (22 cm) Diameter: 7 7/8 in. (20 cm) Georgian National Museum, Sh. Amiranashvili Museum of Fine Arts (Or3682) Attributed to|Country of Origin 41   | 96   Georgia|Georgia 1033             Metal 1   http://www.metmuseum.org/art/collection/search/655795 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 468.856ms · Data license: CC0 · Data source: metmuseum/openaccess